Visit the VBA barcode macros home page for the most up to date information
[BizFonts.com Home Page | Excel Barcode Macro Tutorial | Access Barcode Macro Tutorial]
Our Bar Code VBA macros for Microsoft Excel and Microsoft Access work with our POSTNET, Code 39, Interleaved 2 of 5, Code 128, UPC-A, EAN-13, EAN-8, UCC-128, MSI / Plessy, Code 11, SSCC-18 and SCC-14 barcode fonts and specifications. The macros (which consist of VBA code and functions) will generate check digits, add the start and stop characters and format the return string for one of our barcode fonts. The macros can be easily integrated into your application for automation purposes and you don't have to be a programmer to use them. The barcode macros and functions are easy enough for intermediate and advanced users of Excel or Access.
The macros and VBA functions are ready to install and are only designed to calculate barcode strings for the barcode fonts available at the http://www.BizFonts.com website. The macros, functions and Visual Basic source code are free to use as long as you are using them with one of our barcode fonts. They are compatible with Microsoft Office 97 and Microsoft Office 2000.
NOTE: You MUST use Code 128 fonts version 2.0 and above for the Code 128 and UCC128 functions.
For all functions below the input type is a single string. For all number symbologies such as POSTNET and UPC, you may input dashes or spaces for easier readability and they will be filtered out by the function before the barcode is generated. For UPC-A, UPC-E & EAN-13 you can enter the +2 and +5 add-on codes by just adding them to the end of the string.
| Function | Notes |
| Code128a() | Use the characters from set B to print characters not on the keyboard; the scanner will scan characters from set A. |
| Code128b() | |
| Code128c() | This code128 function "interleaves" numbers into pairs for high density. |
| Interleaved2of5() | This function also "interleaves" numbers into pairs for high density without check digits. |
| Interleaved2of5Mod10() | Performs the mod10 checksum calculation for increased accuracy. Required by USPS for special services. |
| Code39() | |
| Code39Mod43() | Performs the mod43 checksum calculation for increased accuracy. |
| Codabar() | |
| UCC128() | Supports UCC-128, EAN-128, SCC-18 and SCC-14. FNC1 automatically included after start digit, enter "FA" between even numbers for additional FNC1 Codes. |
| Postnet() | Enter a single string of Zip, Zip + 4 or Zip + 4 + Delivery Point. |
| RM4SCC() | Checksum calculated according to the mailsort customer barcoding specification. |
| MSI() | |
| Code11() | Only the "C" check digit is calculated which is the standard when encoding 10 digits or less. |
| UPCa() | Enter UPC-A with or without a check digit, add-ons are supported. |
| UPCe() | Enter the full 11 or 12 digit UPC-A number. The purpose of this function is to print the UPC-E barcode from a UPC-A barcode that can be compressed. It will print a UPC-A if it cannot be compressed by zero suppression rules. |
| EAN13() | Enter EAN-13 with or without a check digit, add-ons are supported. |
| EAN8() | Enter exactly 7 characters (EAN-8 without the check digit). |
After you have downloaded and extracted the files, open the Excel spreadsheet provided. If asked to enable Macros, choose Yes. View the formula in the cells listed under the "Barcode To Scan" column. It is this formula that retrieves the data to encode and passes it to the appropriate barcode function. The function will then format the data to encode in a string formatted to the barcode. Then, the font must be selected for the cell and MUST be the same symbology. For example, the formula in cell C15 is "=Code128b(B15)" and the font selected for this cell is AdvC128b. Fully functional versions of our fonts must be installed to create a proper barcode.
The VBA code and functions reside inside the Excel file. This makes it easy to deploy barcode applications for users that already use Excel. To use these functions in another Excel file you must first export the module and import it into the other Excel spreadsheet.
To export choose Tools - Macro - Visual Basic Editor. Then choose View - Project Explorer. Highlight "Module1" within the Modules folder and choose File - Export File. Choose a name for the exported file such as "barcode.bas".
To import the VBA functions into a new spreadsheet, choose Tools - Macro - Visual Basic Editor. Then choose File - Import File. Highlight the module you exported and choose Open. Close the Visual Basic Editor; you are now ready to use the VBA functions in the new spreadsheet.
After you have downloaded and extracted the files, open the Access Database provided. The Database we provide contains one table, two reports and one module. The module contains the VBA code, functions and macros. To pass data to the function and return it in a report you would place the formula =function([table.field]) in the control source field. View the design of the reports to gain an understanding of how the bar code macros work. Fully functional versions of our fonts must be installed to create a proper barcode.
The VBA code and functions reside inside the access database as a module. This makes it easy to deploy barcode applications for users that already use Access. To use these functions in another Access file you must copy the module to another database or first export the module and then import it into the other database.
To copy the module to another database choose the Modules folder. Highlight the "BarcodeVBA" module and choose File - Save as. Choose to save the module to an external file. Choose the file you want to copy the module to and choose OK.
To export: choose the Modules folder. Highlight the "BarcodeVBA" module and choose File - Save as. Choose to save the module to an external file. Choose a name for the exported file such as "barcode.txt".
To import: choose the Modules folder. Choose Insert - Module, then choose Insert - File. Choose the file you exported the module into and save the module when asked.
Copyright © AdvanceMeants, Inc. All rights reserved. All trademarks mentioned are the property of their respective owners.